use Rated
go

insert RatedItemType([Text],[Domain]) values ('DJ', 'rateddjs.com')
insert RatedItemType([Text],[Domain]) values ('Band','ratedbands.com')
insert RatedItemType([Text],[Domain]) values ('Venue','ratedvenues.com')
insert RatedItemType([Text],[Domain]) values ('Photographer','ratedphotographers.com')
insert RatedItemType([Text],[Domain]) values ('Florist','ratedflorists.com')
go

insert AttributeType([Text],[Title]) values ('Suitability','Suitable For')
insert AttributeType([Text],[Title]) values ('Genre','Genres')
go


insert ItemType_AttributeType (ID,ItemTypeID) values (1,1)
insert ItemType_AttributeType (ID,ItemTypeID) values (2,1)
insert ItemType_AttributeType (ID,ItemTypeID) values (3,1)
go

/* AttributeID 1 == Suitability */
insert Attribute(AttributeTypeID,[Text]) values (1, 'Engagements')
insert Attribute(AttributeTypeID,[Text]) values (1, 'Office Parties')
insert Attribute(AttributeTypeID,[Text]) values (1, 'Childrens Parties')
/* AttributeID 2 == Genre */
insert Attribute(AttributeTypeID,[Text]) values (2, 'Reggae')
insert Attribute(AttributeTypeID,[Text]) values (2, 'Soul')
insert Attribute(AttributeTypeID,[Text]) values (2, '80s Disco')
insert Attribute(AttributeTypeID,[Text]) values (2, 'Death Metal')
go


/* Now lets add some RatedItems */
insert RatedItem(RatedItemTypeID,[Title],[Description],[OwnerID],[Rating])
values
(1,  -- DJ
'Robbie Owen Musical Entertainer',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.',
1, -- sportsqs@gmail.com
3.5)

insert RatedItem(RatedItemTypeID,[Title],[Description],[OwnerID],[Rating])
values
(1,  -- DJ
'David Guetta',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.',
1, -- sportsqs@gmail.com
3.5)
go

insert RatedItem(RatedItemTypeID,[Title],[Description],[OwnerID],[Rating])
values
(1,  -- DJ
'Calvin Harris',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.',
1, -- sportsqs@gmail.com
3.5)
go

insert RatedItem(RatedItemTypeID,[Title],[Description],[OwnerID],[Rating])
values
(1,  -- DJ
'Phil Jones',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.',
1, -- sportsqs@gmail.com
3.5)
go

insert RatedItem(RatedItemTypeID,[Title],[Description],[OwnerID],[Rating])
values
(1,  -- DJ
'Big Bad Bob',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.',
1, -- sportsqs@gmail.com
3.5)
go

insert RatedItem(RatedItemTypeID,[Title],[Description],[OwnerID],[Rating])
values
(1,  -- DJ
'Nicky the Disk',
'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.',
1, -- sportsqs@gmail.com
3.5)
go


insert RatedItem_Attribute(RatedItemID,AttributeID) values (1,15)
insert RatedItem_Attribute(RatedItemID,AttributeID) values (1,16)
insert RatedItem_Attribute(RatedItemID,AttributeID) values (1,17)


insert RatedItem_Attribute(RatedItemID,AttributeID) values (1,18)
insert RatedItem_Attribute(RatedItemID,AttributeID) values (1,19)
insert RatedItem_Attribute(RatedItemID,AttributeID) values (1,20)


insert RatedItem_Attribute(RatedItemID,AttributeID) values (2,15)
insert RatedItem_Attribute(RatedItemID,AttributeID) values (2,16)
go



insert [image] (RatedItemID, [Filename], Extension, Title, IsDefault)
values (1,'34FFCA52-3154-42E8-B3DE-F80AC38F011E','jpg','XMas Eve 2014',0)

insert [image] (RatedItemID, [Filename], Extension, Title, IsDefault)
values (1,'AABC8D1E-87BD-443B-A8A8-E5DD1D44EF7C','jpg','Main Image',1)

go

insert SubscriptionType(Title) values ('Basic')
insert SubscriptionType(Title) values ('Premium')
go

update RatedItemType set RankText = 'DJs' where [Text]='DJ'
update RatedItemType set RankText = 'Bands' where [Text]='Band'
update RatedItemType set RankText = 'Venues' where [Text]='Venue'
update RatedItemType set RankText = 'Photographers' where [Text]='Photographer'
update RatedItemType set RankText = 'Florists' where [Text]='Florist'
go

insert Continent([Name]) values ('Asia')
insert Continent([Name]) values ('Africa')
insert Continent([Name]) values ('North America')
insert Continent([Name]) values ('South America')
insert Continent([Name]) values ('Antarctica')
insert Continent([Name]) values ('Europe')
insert Continent([Name]) values ('Australia')

go

insert country([Name], ContinentID) values('United Kingdom',6)
go

insert Locality([Name], CountryID) values('North East Wales',1)
insert Locality([Name], CountryID) values('North West Wales',1)
insert Locality([Name], CountryID) values('South East Wales',1)
insert Locality([Name], CountryID) values('North West Wales',1)
insert Locality([Name], CountryID) values('Mid Wales',1)
go

insert [State]([Name], LocalityID) values('Bridgend',3)
insert [State]([Name], LocalityID) values('Vale of Glamorgan',3)
insert [State]([Name], LocalityID) values('Rhondda Cynon Taff',3)
insert [State]([Name], LocalityID) values('Newport',3)
insert [State]([Name], LocalityID) values('Cardiff',3)
insert [State]([Name], LocalityID) values('Merthyr Tydfil',3)
insert [State]([Name], LocalityID) values('Blaenau Gwent',3)
insert [State]([Name], LocalityID) values('Caerphilly',3)
insert [State]([Name], LocalityID) values('Torfaen',3)
go
insert City([Name], StateID) values ('Brackla',1)
insert City([Name], StateID) values ('Bridgend',1)
insert City([Name], StateID) values ('Cefn Cribwr',1)
insert City([Name], StateID) values ('Coity',1)
insert City([Name], StateID) values ('Cornelly',1)
insert City([Name], StateID) values ('Coychurch',1)
insert City([Name], StateID) values ('Laleston',1)
insert City([Name], StateID) values ('Llangynwyd',1)
insert City([Name], StateID) values ('Maesteg',1)
insert City([Name], StateID) values ('Merthyr Mawr',1)
insert City([Name], StateID) values ('Newcastle',1)
insert City([Name], StateID) values ('Ogmore Valley',1)
insert City([Name], StateID) values ('Pencoed',1)
insert City([Name], StateID) values ('Porthcawl',1)
insert City([Name], StateID) values ('Pyle',1)
insert City([Name], StateID) values ('St Bride''s Minor',1)
insert City([Name], StateID) values ('Ynysawdre',1)







